# Load sqlite library
require "sqlite3"

# Load database
db = SQLite3::Database.new( "fruit.db" )

#Prompt user for search query
puts "Which fruit?"

# A place to accept user input
keyword = gets

# Define sql statement
sql = "select price from fruit where fruit = '#{keyword.chomp!}'"
result = db.execute sql
puts "The price of " + keyword + " is: "
puts result
puts "per pound"